Forum Discussion

Lin Wang's avatar
Lin Wang
Copper Contributor
Mar 10, 2017
Solved

Data/What If/Data Table Problems

Hi I'm trying to set up a children attendance and payment work sheet.  I need help as to how to set up a formular to calculate payment depending on number of children attending.  So basically if cell...
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Mar 10, 2017

    Hi Lin,

     

    Simply, you have to use somthing like this:

     

    =IF(NOT(ISNUMBER(E2)),"",
IF(E2=0,0,
IF(E2=1,4,
IF(E2=2,6,
IF(E2>=3,8,
)))))
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Mar 10, 2017

Hi Lin,

 

Simply, you have to use somthing like this:

 

=IF(NOT(ISNUMBER(E2)),"",
IF(E2=0,0,
IF(E2=1,4,
IF(E2=2,6,
IF(E2>=3,8,
)))))

Resources