I have (column a) that gets a "y" or "n" when its a "y" i need to add 8 to cell h2. I keep getting problems with my formula help please.
I have (column a) that gets a "y" or "n" when its a "y" i need to add 8 to cell h2. I keep getting problems with my formula help please.
h2 cell = if(a2="y",8,0) or if(a2="y",{cell reference}+8,{cell reference})
if it doesnt solve your problem please add a file and simulate problem there with desired output
Appreciate the help? CLICK *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks